{
  "statement":"SELECT `L_LINENUMBER`, `L_EXTENDEDPRICE`, `L_RECEIPTDATE` FROM (SELECT `lineitem_l`.`L_LINENUMBER`, `lineitem_l`.`L_EXTENDEDPRICE`, `lineitem_l`.`L_RECEIPTDATE`, `t2`.`$f0` FROM `tpch_100g`.`lineitem_l` LEFT JOIN (SELECT MIN(TRUE) AS `$f0` FROM `tpch_100g`.`test_all_type_select` CROSS JOIN `tpch_100g`.`FLAT_TEST_TABLE` CROSS JOIN `tpch_100g`.`partsupp_50_null` CROSS JOIN `tpch_100g`.`customer_25_null` CROSS JOIN `tpch_100g`.`customer_50_null` CROSS JOIN `tpch_100g`.`nation_25_null` CROSS JOIN `tpch_100g`.`orders_l` CROSS JOIN `tpch_100g`.`part` CROSS JOIN `tpch_100g`.`customer_5_null` CROSS JOIN `tpch_100g`.`region_5_null` CROSS JOIN `tpch_100g`.`partsupp` CROSS JOIN `tpch_100g`.`partsupp_25_null` CROSS JOIN `tpch_100g`.`region` CROSS JOIN `tpch_100g`.`orders_str` CROSS JOIN `tpch_100g`.`orders` CROSS JOIN `tpch_100g`.`orders_25_null` CROSS JOIN `tpch_100g`.`region_50_null` CROSS JOIN `tpch_100g`.`customer` CROSS JOIN `tpch_100g`.`lineitem_l` AS `lineitem_l0` CROSS JOIN `tpch_100g`.`orders_lco` CROSS JOIN (SELECT * FROM `tpch_100g`.`supplier_25_null`) AS `t` FULL JOIN (SELECT `O_ORDERKEY`, `O_CUSTKEY`, `O_ORDERSTATUS`, `O_TOTALPRICE`, `O_ORDERDATE`, `O_ORDERPRIORITY`, `O_CLERK`, `O_SHIPPRIORITY`, `O_COMMENT`, CAST(`O_ORDERKEY` AS INTEGER) AS `O_ORDERKEY0` FROM `tpch_100g`.`orders_str_co`) AS `t0` ON `t`.`S_SUPPKEY` \u003d `t0`.`O_ORDERKEY0`) AS `t2` ON TRUE GROUP BY `lineitem_l`.`L_LINENUMBER`, `lineitem_l`.`L_EXTENDEDPRICE`, `lineitem_l`.`L_RECEIPTDATE`, `t2`.`$f0`) AS `t3` WHERE `t3`.`$f0` IS NOT NULL GROUP BY `L_LINENUMBER`, `L_EXTENDEDPRICE`, `L_RECEIPTDATE` LIMIT 19205;\n",
  "table_meta":{
    "tpch_100g.FLAT_TEST_TABLE":"CREATE TABLE `FLAT_TEST_TABLE` (\n  `S_SUPPKEY` int(11) NOT NULL COMMENT \"\",\n  `N_NATIONKEY` int(11) NOT NULL COMMENT \"\",\n  `N_COMMENT` varchar(152) NULL COMMENT \"\"\n) ENGINE\u003dOLAP \nDUPLICATE KEY(`S_SUPPKEY`)\nCOMMENT \"OLAP\"\nDISTRIBUTED BY HASH(`S_SUPPKEY`) BUCKETS 6 \nPROPERTIES (\n\"replication_num\" \u003d \"1\",\n\"in_memory\" \u003d \"false\",\n\"storage_format\" \u003d \"V2\",\n\"enable_persistent_index\" \u003d \"false\"\n);",
    "tpch_100g.customer":"CREATE TABLE `customer` (\n  `C_CUSTKEY` int(11) NOT NULL COMMENT \"\",\n  `C_NAME` varchar(25) NOT NULL COMMENT \"\",\n  `C_ADDRESS` varchar(40) NOT NULL COMMENT \"\",\n  `C_NATIONKEY` int(11) NOT NULL COMMENT \"\",\n  `C_PHONE` char(15) NOT NULL COMMENT \"\",\n  `C_ACCTBAL` decimal(15, 2) NOT NULL COMMENT \"\",\n  `C_MKTSEGMENT` char(10) NOT NULL COMMENT \"\",\n  `C_COMMENT` varchar(117) NOT NULL COMMENT \"\"\n) ENGINE\u003dOLAP \nDUPLICATE KEY(`C_CUSTKEY`)\nCOMMENT \"OLAP\"\nDISTRIBUTED BY HASH(`C_CUSTKEY`) BUCKETS 12 \nPROPERTIES (\n\"replication_num\" \u003d \"1\",\n\"colocate_with\" \u003d \"groupxcdffsisdf\",\n\"in_memory\" \u003d \"false\",\n\"storage_format\" \u003d \"V2\",\n\"enable_persistent_index\" \u003d \"false\"\n);",
    "tpch_100g.customer_25_null":"CREATE TABLE `customer_25_null` (\n  `C_CUSTKEY` int(11) NULL COMMENT \"\",\n  `C_NAME` varchar(25) NULL COMMENT \"\",\n  `C_ADDRESS` varchar(40) NULL COMMENT \"\",\n  `C_NATIONKEY` int(11) NULL COMMENT \"\",\n  `C_PHONE` char(15) NULL COMMENT \"\",\n  `C_ACCTBAL` decimal(15, 2) NULL COMMENT \"\",\n  `C_MKTSEGMENT` char(10) NULL COMMENT \"\",\n  `C_COMMENT` varchar(117) NULL COMMENT \"\"\n) ENGINE\u003dOLAP \nDUPLICATE KEY(`C_CUSTKEY`)\nCOMMENT \"OLAP\"\nDISTRIBUTED BY HASH(`C_CUSTKEY`) BUCKETS 12 \nPROPERTIES (\n\"replication_num\" \u003d \"1\",\n\"colocate_with\" \u003d \"groupxcdffsisdf\",\n\"in_memory\" \u003d \"false\",\n\"storage_format\" \u003d \"V2\",\n\"enable_persistent_index\" \u003d \"false\"\n);",
    "tpch_100g.customer_50_null":"CREATE TABLE `customer_50_null` (\n  `C_CUSTKEY` int(11) NULL COMMENT \"\",\n  `C_NAME` varchar(25) NULL COMMENT \"\",\n  `C_ADDRESS` varchar(40) NULL COMMENT \"\",\n  `C_NATIONKEY` int(11) NULL COMMENT \"\",\n  `C_PHONE` char(15) NULL COMMENT \"\",\n  `C_ACCTBAL` decimal(15, 2) NULL COMMENT \"\",\n  `C_MKTSEGMENT` char(10) NULL COMMENT \"\",\n  `C_COMMENT` varchar(117) NULL COMMENT \"\"\n) ENGINE\u003dOLAP \nDUPLICATE KEY(`C_CUSTKEY`)\nCOMMENT \"OLAP\"\nDISTRIBUTED BY HASH(`C_CUSTKEY`) BUCKETS 12 \nPROPERTIES (\n\"replication_num\" \u003d \"1\",\n\"colocate_with\" \u003d \"groupxcdffsisdf\",\n\"in_memory\" \u003d \"false\",\n\"storage_format\" \u003d \"V2\",\n\"enable_persistent_index\" \u003d \"false\"\n);",
    "tpch_100g.customer_5_null":"CREATE TABLE `customer_5_null` (\n  `C_CUSTKEY` int(11) NULL COMMENT \"\",\n  `C_NAME` varchar(25) NULL COMMENT \"\",\n  `C_ADDRESS` varchar(40) NULL COMMENT \"\",\n  `C_NATIONKEY` int(11) NULL COMMENT \"\",\n  `C_PHONE` char(15) NULL COMMENT \"\",\n  `C_ACCTBAL` decimal(15, 2) NULL COMMENT \"\",\n  `C_MKTSEGMENT` char(10) NULL COMMENT \"\",\n  `C_COMMENT` varchar(117) NULL COMMENT \"\"\n) ENGINE\u003dOLAP \nDUPLICATE KEY(`C_CUSTKEY`)\nCOMMENT \"OLAP\"\nDISTRIBUTED BY HASH(`C_CUSTKEY`) BUCKETS 12 \nPROPERTIES (\n\"replication_num\" \u003d \"1\",\n\"colocate_with\" \u003d \"groupxcdffsisdf\",\n\"in_memory\" \u003d \"false\",\n\"storage_format\" \u003d \"V2\",\n\"enable_persistent_index\" \u003d \"false\"\n);",
    "tpch_100g.lineitem_l":"CREATE TABLE `lineitem_l` (\n  `L_ORDERKEY` int(11) NOT NULL COMMENT \"\",\n  `L_PARTKEY` int(11) NOT NULL COMMENT \"\",\n  `L_SUPPKEY` int(11) NOT NULL COMMENT \"\",\n  `L_LINENUMBER` int(11) NOT NULL COMMENT \"\",\n  `L_QUANTITY` decimal(15, 2) NOT NULL COMMENT \"\",\n  `L_EXTENDEDPRICE` decimal(15, 2) NOT NULL COMMENT \"\",\n  `L_DISCOUNT` decimal(15, 2) NOT NULL COMMENT \"\",\n  `L_TAX` decimal(15, 2) NOT NULL COMMENT \"\",\n  `L_RETURNFLAG` char(1) NOT NULL COMMENT \"\",\n  `L_LINESTATUS` char(1) NOT NULL COMMENT \"\",\n  `L_SHIPDATE` date NOT NULL COMMENT \"\",\n  `L_COMMITDATE` date NOT NULL COMMENT \"\",\n  `L_RECEIPTDATE` date NOT NULL COMMENT \"\",\n  `L_SHIPINSTRUCT` char(25) NOT NULL COMMENT \"\",\n  `L_SHIPMODE` char(10) NOT NULL COMMENT \"\",\n  `L_COMMENT` varchar(44) NOT NULL COMMENT \"\"\n) ENGINE\u003dOLAP \nDUPLICATE KEY(`L_ORDERKEY`)\nCOMMENT \"OLAP\"\nDISTRIBUTED BY HASH(`L_ORDERKEY`) BUCKETS 192 \nPROPERTIES (\n\"replication_num\" \u003d \"1\",\n\"colocate_with\" \u003d \"group201\",\n\"in_memory\" \u003d \"false\",\n\"storage_format\" \u003d \"V2\",\n\"enable_persistent_index\" \u003d \"false\"\n);",
    "tpch_100g.nation_25_null":"CREATE TABLE `nation_25_null` (\n  `N_NATIONKEY` int(11) NULL COMMENT \"\",\n  `N_NAME` char(25) NULL COMMENT \"\",\n  `N_REGIONKEY` int(11) NULL COMMENT \"\",\n  `N_COMMENT` varchar(152) NULL COMMENT \"\"\n) ENGINE\u003dOLAP \nDUPLICATE KEY(`N_NATIONKEY`)\nCOMMENT \"OLAP\"\nDISTRIBUTED BY HASH(`N_NATIONKEY`) BUCKETS 1 \nPROPERTIES (\n\"replication_num\" \u003d \"1\",\n\"in_memory\" \u003d \"false\",\n\"storage_format\" \u003d \"V2\",\n\"enable_persistent_index\" \u003d \"false\"\n);",
    "tpch_100g.orders":"CREATE TABLE `orders` (\n  `O_ORDERKEY` int(11) NOT NULL COMMENT \"\",\n  `O_CUSTKEY` int(11) NOT NULL COMMENT \"\",\n  `O_ORDERSTATUS` char(1) NOT NULL COMMENT \"\",\n  `O_TOTALPRICE` decimal(15, 2) NOT NULL COMMENT \"\",\n  `O_ORDERDATE` date NOT NULL COMMENT \"\",\n  `O_ORDERPRIORITY` char(15) NOT NULL COMMENT \"\",\n  `O_CLERK` char(15) NOT NULL COMMENT \"\",\n  `O_SHIPPRIORITY` int(11) NOT NULL COMMENT \"\",\n  `O_COMMENT` varchar(79) NOT NULL COMMENT \"\"\n) ENGINE\u003dOLAP \nDUPLICATE KEY(`O_ORDERKEY`)\nCOMMENT \"OLAP\"\nDISTRIBUTED BY HASH(`O_ORDERKEY`) BUCKETS 12 \nPROPERTIES (\n\"replication_num\" \u003d \"1\",\n\"in_memory\" \u003d \"false\",\n\"storage_format\" \u003d \"V2\",\n\"enable_persistent_index\" \u003d \"false\"\n);",
    "tpch_100g.orders_25_null":"CREATE TABLE `orders_25_null` (\n  `O_ORDERKEY` int(11) NULL COMMENT \"\",\n  `O_CUSTKEY` int(11) NULL COMMENT \"\",\n  `O_ORDERSTATUS` char(1) NULL COMMENT \"\",\n  `O_TOTALPRICE` decimal(15, 2) NULL COMMENT \"\",\n  `O_ORDERDATE` date NULL COMMENT \"\",\n  `O_ORDERPRIORITY` char(15) NULL COMMENT \"\",\n  `O_CLERK` char(15) NULL COMMENT \"\",\n  `O_SHIPPRIORITY` int(11) NULL COMMENT \"\",\n  `O_COMMENT` varchar(79) NULL COMMENT \"\"\n) ENGINE\u003dOLAP \nDUPLICATE KEY(`O_ORDERKEY`)\nCOMMENT \"OLAP\"\nDISTRIBUTED BY HASH(`O_ORDERKEY`) BUCKETS 192 \nPROPERTIES (\n\"replication_num\" \u003d \"1\",\n\"colocate_with\" \u003d \"group201\",\n\"in_memory\" \u003d \"false\",\n\"storage_format\" \u003d \"V2\",\n\"enable_persistent_index\" \u003d \"false\"\n);",
    "tpch_100g.orders_l":"CREATE TABLE `orders_l` (\n  `O_ORDERKEY` int(11) NOT NULL COMMENT \"\",\n  `O_CUSTKEY` int(11) NOT NULL COMMENT \"\",\n  `O_ORDERSTATUS` char(1) NOT NULL COMMENT \"\",\n  `O_TOTALPRICE` decimal(15, 2) NOT NULL COMMENT \"\",\n  `O_ORDERDATE` date NOT NULL COMMENT \"\",\n  `O_ORDERPRIORITY` char(15) NOT NULL COMMENT \"\",\n  `O_CLERK` char(15) NOT NULL COMMENT \"\",\n  `O_SHIPPRIORITY` int(11) NOT NULL COMMENT \"\",\n  `O_COMMENT` varchar(79) NOT NULL COMMENT \"\"\n) ENGINE\u003dOLAP \nDUPLICATE KEY(`O_ORDERKEY`)\nCOMMENT \"OLAP\"\nDISTRIBUTED BY HASH(`O_ORDERKEY`) BUCKETS 192 \nPROPERTIES (\n\"replication_num\" \u003d \"1\",\n\"colocate_with\" \u003d \"gsdaf2449s9e\",\n\"in_memory\" \u003d \"false\",\n\"storage_format\" \u003d \"V2\",\n\"enable_persistent_index\" \u003d \"false\"\n);",
    "tpch_100g.orders_lco":"CREATE TABLE `orders_lco` (\n  `O_ORDERKEY` int(11) NOT NULL COMMENT \"\",\n  `O_CUSTKEY` int(11) NOT NULL COMMENT \"\",\n  `O_ORDERSTATUS` char(1) NOT NULL COMMENT \"\",\n  `O_TOTALPRICE` decimal(15, 2) NOT NULL COMMENT \"\",\n  `O_ORDERDATE` date NOT NULL COMMENT \"\",\n  `O_ORDERPRIORITY` char(15) NOT NULL COMMENT \"\",\n  `O_CLERK` char(15) NOT NULL COMMENT \"\",\n  `O_SHIPPRIORITY` int(11) NOT NULL COMMENT \"\",\n  `O_COMMENT` varchar(79) NOT NULL COMMENT \"\"\n) ENGINE\u003dOLAP \nDUPLICATE KEY(`O_ORDERKEY`)\nCOMMENT \"OLAP\"\nDISTRIBUTED BY HASH(`O_ORDERKEY`) BUCKETS 192 \nPROPERTIES (\n\"replication_num\" \u003d \"1\",\n\"colocate_with\" \u003d \"group200\",\n\"in_memory\" \u003d \"false\",\n\"storage_format\" \u003d \"V2\",\n\"enable_persistent_index\" \u003d \"false\"\n);",
    "tpch_100g.orders_str":"CREATE TABLE `orders_str` (\n  `O_ORDERKEY` varchar(64) NOT NULL COMMENT \"\",\n  `O_CUSTKEY` varchar(64) NOT NULL COMMENT \"\",\n  `O_ORDERSTATUS` char(1) NOT NULL COMMENT \"\",\n  `O_TOTALPRICE` varchar(64) NOT NULL COMMENT \"\",\n  `O_ORDERDATE` varchar(64) NOT NULL COMMENT \"\",\n  `O_ORDERPRIORITY` char(15) NOT NULL COMMENT \"\",\n  `O_CLERK` char(15) NOT NULL COMMENT \"\",\n  `O_SHIPPRIORITY` varchar(64) NOT NULL COMMENT \"\",\n  `O_COMMENT` varchar(79) NOT NULL COMMENT \"\"\n) ENGINE\u003dOLAP \nDUPLICATE KEY(`O_ORDERKEY`)\nCOMMENT \"OLAP\"\nDISTRIBUTED BY HASH(`O_ORDERKEY`) BUCKETS 192 \nPROPERTIES (\n\"replication_num\" \u003d \"1\",\n\"colocate_with\" \u003d \"lineitem_str_g3\",\n\"in_memory\" \u003d \"false\",\n\"storage_format\" \u003d \"V2\",\n\"enable_persistent_index\" \u003d \"false\"\n);",
    "tpch_100g.orders_str_co":"CREATE TABLE `orders_str_co` (\n  `O_ORDERKEY` varchar(64) NOT NULL COMMENT \"\",\n  `O_CUSTKEY` varchar(64) NOT NULL COMMENT \"\",\n  `O_ORDERSTATUS` char(1) NOT NULL COMMENT \"\",\n  `O_TOTALPRICE` varchar(64) NOT NULL COMMENT \"\",\n  `O_ORDERDATE` varchar(64) NOT NULL COMMENT \"\",\n  `O_ORDERPRIORITY` char(15) NOT NULL COMMENT \"\",\n  `O_CLERK` char(15) NOT NULL COMMENT \"\",\n  `O_SHIPPRIORITY` varchar(64) NOT NULL COMMENT \"\",\n  `O_COMMENT` varchar(79) NOT NULL COMMENT \"\"\n) ENGINE\u003dOLAP \nDUPLICATE KEY(`O_ORDERKEY`)\nCOMMENT \"OLAP\"\nDISTRIBUTED BY HASH(`O_ORDERKEY`) BUCKETS 12 \nPROPERTIES (\n\"replication_num\" \u003d \"1\",\n\"colocate_with\" \u003d \"lineitem_str_g1\",\n\"in_memory\" \u003d \"false\",\n\"storage_format\" \u003d \"V2\",\n\"enable_persistent_index\" \u003d \"false\"\n);",
    "tpch_100g.part":"CREATE TABLE `part` (\n  `P_PARTKEY` int(11) NOT NULL COMMENT \"\",\n  `P_NAME` varchar(55) NOT NULL COMMENT \"\",\n  `P_MFGR` char(25) NOT NULL COMMENT \"\",\n  `P_BRAND` char(10) NOT NULL COMMENT \"\",\n  `P_TYPE` varchar(25) NOT NULL COMMENT \"\",\n  `P_SIZE` int(11) NOT NULL COMMENT \"\",\n  `P_CONTAINER` char(10) NOT NULL COMMENT \"\",\n  `P_RETAILPRICE` decimal(15, 2) NOT NULL COMMENT \"\",\n  `P_COMMENT` varchar(23) NOT NULL COMMENT \"\"\n) ENGINE\u003dOLAP \nDUPLICATE KEY(`P_PARTKEY`)\nCOMMENT \"OLAP\"\nDISTRIBUTED BY HASH(`P_PARTKEY`) BUCKETS 12 \nPROPERTIES (\n\"replication_num\" \u003d \"1\",\n\"in_memory\" \u003d \"false\",\n\"storage_format\" \u003d \"V2\",\n\"enable_persistent_index\" \u003d \"false\"\n);",
    "tpch_100g.partsupp":"CREATE TABLE `partsupp` (\n  `PS_PARTKEY` int(11) NOT NULL COMMENT \"\",\n  `PS_SUPPKEY` int(11) NOT NULL COMMENT \"\",\n  `PS_AVAILQTY` int(11) NOT NULL COMMENT \"\",\n  `PS_SUPPLYCOST` decimal(15, 2) NOT NULL COMMENT \"\",\n  `PS_COMMENT` varchar(199) NOT NULL COMMENT \"\"\n) ENGINE\u003dOLAP \nDUPLICATE KEY(`PS_PARTKEY`)\nCOMMENT \"OLAP\"\nDISTRIBUTED BY HASH(`PS_PARTKEY`) BUCKETS 12 \nPROPERTIES (\n\"replication_num\" \u003d \"1\",\n\"colocate_with\" \u003d \"grosdf123o\",\n\"in_memory\" \u003d \"false\",\n\"storage_format\" \u003d \"V2\",\n\"enable_persistent_index\" \u003d \"false\"\n);",
    "tpch_100g.partsupp_25_null":"CREATE TABLE `partsupp_25_null` (\n  `PS_PARTKEY` int(11) NULL COMMENT \"\",\n  `PS_SUPPKEY` int(11) NULL COMMENT \"\",\n  `PS_AVAILQTY` int(11) NULL COMMENT \"\",\n  `PS_SUPPLYCOST` decimal(15, 2) NULL COMMENT \"\",\n  `PS_COMMENT` varchar(199) NULL COMMENT \"\"\n) ENGINE\u003dOLAP \nDUPLICATE KEY(`PS_PARTKEY`)\nCOMMENT \"OLAP\"\nDISTRIBUTED BY HASH(`PS_PARTKEY`) BUCKETS 12 \nPROPERTIES (\n\"replication_num\" \u003d \"1\",\n\"colocate_with\" \u003d \"grosdf123o\",\n\"in_memory\" \u003d \"false\",\n\"storage_format\" \u003d \"V2\",\n\"enable_persistent_index\" \u003d \"false\"\n);",
    "tpch_100g.partsupp_50_null":"CREATE TABLE `partsupp_50_null` (\n  `PS_PARTKEY` int(11) NULL COMMENT \"\",\n  `PS_SUPPKEY` int(11) NULL COMMENT \"\",\n  `PS_AVAILQTY` int(11) NULL COMMENT \"\",\n  `PS_SUPPLYCOST` decimal(15, 2) NULL COMMENT \"\",\n  `PS_COMMENT` varchar(199) NULL COMMENT \"\"\n) ENGINE\u003dOLAP \nDUPLICATE KEY(`PS_PARTKEY`)\nCOMMENT \"OLAP\"\nDISTRIBUTED BY HASH(`PS_PARTKEY`) BUCKETS 12 \nPROPERTIES (\n\"replication_num\" \u003d \"1\",\n\"colocate_with\" \u003d \"grosdf123o\",\n\"in_memory\" \u003d \"false\",\n\"storage_format\" \u003d \"V2\",\n\"enable_persistent_index\" \u003d \"false\"\n);",
    "tpch_100g.region":"CREATE TABLE `region` (\n  `R_REGIONKEY` int(11) NOT NULL COMMENT \"\",\n  `R_NAME` char(25) NOT NULL COMMENT \"\",\n  `R_COMMENT` varchar(152) NULL COMMENT \"\"\n) ENGINE\u003dOLAP \nDUPLICATE KEY(`R_REGIONKEY`)\nCOMMENT \"OLAP\"\nDISTRIBUTED BY HASH(`R_REGIONKEY`) BUCKETS 1 \nPROPERTIES (\n\"replication_num\" \u003d \"1\",\n\"in_memory\" \u003d \"false\",\n\"storage_format\" \u003d \"V2\",\n\"enable_persistent_index\" \u003d \"false\"\n);",
    "tpch_100g.region_50_null":"CREATE TABLE `region_50_null` (\n  `R_REGIONKEY` int(11) NULL COMMENT \"\",\n  `R_NAME` char(25) NULL COMMENT \"\",\n  `R_COMMENT` varchar(152) NULL COMMENT \"\"\n) ENGINE\u003dOLAP \nDUPLICATE KEY(`R_REGIONKEY`)\nCOMMENT \"OLAP\"\nDISTRIBUTED BY HASH(`R_REGIONKEY`) BUCKETS 1 \nPROPERTIES (\n\"replication_num\" \u003d \"1\",\n\"in_memory\" \u003d \"false\",\n\"storage_format\" \u003d \"V2\",\n\"enable_persistent_index\" \u003d \"false\"\n);",
    "tpch_100g.region_5_null":"CREATE TABLE `region_5_null` (\n  `R_REGIONKEY` int(11) NULL COMMENT \"\",\n  `R_NAME` char(25) NULL COMMENT \"\",\n  `R_COMMENT` varchar(152) NULL COMMENT \"\"\n) ENGINE\u003dOLAP \nDUPLICATE KEY(`R_REGIONKEY`)\nCOMMENT \"OLAP\"\nDISTRIBUTED BY HASH(`R_REGIONKEY`) BUCKETS 1 \nPROPERTIES (\n\"replication_num\" \u003d \"1\",\n\"in_memory\" \u003d \"false\",\n\"storage_format\" \u003d \"V2\",\n\"enable_persistent_index\" \u003d \"false\"\n);",
    "tpch_100g.supplier_25_null":"CREATE TABLE `supplier_25_null` (\n  `S_SUPPKEY` int(11) NULL COMMENT \"\",\n  `S_NAME` char(25) NULL COMMENT \"\",\n  `S_ADDRESS` varchar(40) NULL COMMENT \"\",\n  `S_NATIONKEY` int(11) NULL COMMENT \"\",\n  `S_PHONE` char(15) NULL COMMENT \"\",\n  `S_ACCTBAL` decimal(15, 2) NULL COMMENT \"\",\n  `S_COMMENT` varchar(101) NULL COMMENT \"\"\n) ENGINE\u003dOLAP \nDUPLICATE KEY(`S_SUPPKEY`)\nCOMMENT \"OLAP\"\nDISTRIBUTED BY HASH(`S_SUPPKEY`) BUCKETS 12 \nPROPERTIES (\n\"replication_num\" \u003d \"1\",\n\"colocate_with\" \u003d \"grosdf12sdoq3o\",\n\"in_memory\" \u003d \"false\",\n\"storage_format\" \u003d \"V2\",\n\"enable_persistent_index\" \u003d \"false\"\n);",
    "tpch_100g.test_all_type_select":"CREATE TABLE `test_all_type_select` (\n  `id_int` int(11) NOT NULL COMMENT \"\",\n  `id_int1000` int(11) NOT NULL COMMENT \"\",\n  `id_tinyint` tinyint(4) NOT NULL COMMENT \"\",\n  `id_smallint` smallint(6) NOT NULL COMMENT \"\",\n  `id_bigint` bigint(20) NOT NULL COMMENT \"\",\n  `id_largeint` largeint(40) NOT NULL COMMENT \"\",\n  `id_float` float NOT NULL COMMENT \"\",\n  `id_double` double NOT NULL COMMENT \"\",\n  `id_char` char(20) NOT NULL COMMENT \"\",\n  `id_varchar` varchar(100) NOT NULL COMMENT \"\",\n  `id_varchar_int` varchar(100) NOT NULL COMMENT \"\",\n  `id_varchar_date` varchar(100) NOT NULL COMMENT \"\",\n  `id_varchar_datetime` varchar(100) NOT NULL COMMENT \"\",\n  `id_date` date NOT NULL COMMENT \"\",\n  `id_datetime` datetime NOT NULL COMMENT \"\",\n  `id_decimal` decimal128(20, 3) NOT NULL COMMENT \"\",\n  `id_decimal10` decimal128(20, 9) NOT NULL COMMENT \"\",\n  `id_boolean` boolean NOT NULL COMMENT \"\",\n  `nid_int` int(11) NULL COMMENT \"\",\n  `nid_int1000` int(11) NULL COMMENT \"\",\n  `nid_tinyint` tinyint(4) NULL COMMENT \"\",\n  `nid_smallint` smallint(6) NULL COMMENT \"\",\n  `nid_bigint` bigint(20) NULL COMMENT \"\",\n  `nid_largeint` largeint(40) NULL COMMENT \"\",\n  `nid_float` float NULL COMMENT \"\",\n  `nid_double` double NULL COMMENT \"\",\n  `nid_char` char(20) NULL COMMENT \"\",\n  `nid_varchar` varchar(100) NULL COMMENT \"\",\n  `nid_varchar_int` varchar(100) NULL COMMENT \"\",\n  `nid_varchar_date` varchar(100) NULL COMMENT \"\",\n  `nid_varchar_datetime` varchar(100) NULL COMMENT \"\",\n  `nid_date` date NULL COMMENT \"\",\n  `nid_datetime` datetime NULL COMMENT \"\",\n  `nid_decimal` decimal128(20, 3) NULL COMMENT \"\",\n  `nid_decimal10` decimal128(20, 9) NULL COMMENT \"\",\n  `nid_boolean` boolean NULL COMMENT \"\"\n) ENGINE\u003dOLAP \nDUPLICATE KEY(`id_int`)\nCOMMENT \"OLAP\"\nDISTRIBUTED BY HASH(`id_int`) BUCKETS 10 \nPROPERTIES (\n\"replication_num\" \u003d \"1\",\n\"in_memory\" \u003d \"false\",\n\"storage_format\" \u003d \"DEFAULT\",\n\"enable_persistent_index\" \u003d \"false\"\n);"
  },
  "table_row_count":{
    "tpch_100g.orders":{
      "orders":150000000
    },
    "tpch_100g.part":{
      "part":20000000
    },
    "tpch_100g.lineitem_l":{
      "lineitem_l":600037902
    },
    "tpch_100g.orders_l":{
      "orders_l":150000000
    },
    "tpch_100g.partsupp":{
      "partsupp":80000000
    },
    "tpch_100g.customer":{
      "customer":15000000
    },
    "tpch_100g.region":{
      "region":5
    },
    "tpch_100g.orders_str":{
      "orders_str":150000000
    },
    "tpch_100g.FLAT_TEST_TABLE":{
      "FLAT_TEST_TABLE":16000000
    }
  },
  "session_variables":"{\"enable_resource_group\":false,\"codegen_level\":0,\"cbo_cte_reuse\":false,\"character_set_connection\":\"utf8\",\"cbo_use_correlated_join_estimate\":true,\"enable_insert_strict\":false,\"join_implementation_mode\":\"hash\",\"tx_isolation\":\"REPEATABLE-READ\",\"wait_timeout\":28800,\"cbo_cte_reuse_rate\":1.2,\"foreign_key_checks\":true,\"character_set_results\":\"utf8\",\"enable_global_runtime_filter\":true,\"forward_to_master\":false,\"cbo_enable_low_cardinality_optimize\":true,\"new_planner_optimize_timeout\":3000000,\"force_schedule_local\":false,\"cbo_enable_greedy_join_reorder\":true,\"prefer_join_method\":\"broadcast\",\"load_mem_limit\":0,\"profiling\":false,\"sql_safe_updates\":0,\"global_runtime_filter_probe_min_size\":102400,\"enable_exchange_pass_through_expire\":false,\"enable_vectorized_engine\":true,\"net_write_timeout\":60,\"collation_database\":\"utf8_general_ci\",\"hash_join_push_down_right_table\":true,\"new_planner_agg_stage\":0,\"collation_connection\":\"utf8_general_ci\",\"resource_group\":\"\",\"broadcast_row_limit\":15000000,\"exec_mem_limit\":20179869184,\"cbo_max_reorder_node_use_dp\":10,\"disable_join_reorder\":false,\"enable_profile\":false,\"enable_hive_column_stats\":true,\"enable_groupby_use_output_alias\":false,\"net_buffer_length\":16384,\"query_timeout\":180,\"cbo_max_reorder_node\":50,\"max_execution_time\":3000000,\"runtime_filter_scan_wait_time\":20,\"SQL_AUTO_IS_NULL\":false,\"event_scheduler\":\"OFF\",\"disable_streaming_preaggregations\":false,\"chunk_size\":4096,\"disable_bucket_join\":false,\"runtime_join_filter_push_down_limit\":1024000,\"global_runtime_filter_probe_min_selectivity\":0.5,\"query_mem_limit\":0,\"enable_tablet_internal_parallel\":false,\"enable_filter_unused_columns_in_scan_stage\":false,\"div_precision_increment\":4,\"auto_increment_increment\":1,\"character_set_client\":\"utf8\",\"autocommit\":true,\"enable_column_expr_predicate\":false,\"pipeline_profile_level\":1,\"parallel_fragment_exec_instance_num\":1,\"max_scan_key_num\":-1,\"net_read_timeout\":60,\"streaming_preaggregation_mode\":\"auto\",\"storage_engine\":\"olap\",\"enable_optimizer_trace_log\":false,\"cbo_enable_dp_join_reorder\":true,\"tx_visible_wait_timeout\":10,\"cbo_max_reorder_node_use_exhaustive\":4,\"enable_sql_digest\":false,\"pipeline_dop\":0,\"enable_query_dump\":false,\"single_node_exec_plan\":false,\"global_runtime_filter_build_max_size\":67108864,\"sql_select_limit\":9223372036854775807,\"statistic_collect_parallel\":1,\"query_cache_type\":0,\"disable_colocate_join\":false,\"max_pushdown_conditions_per_column\":-1,\"enable_predicate_reorder\":false,\"workgroup_id\":0,\"transmission_compression_type\":\"LZ4\",\"enable_vectorized_insert\":true,\"interactive_timeout\":3600,\"enable_spilling\":false,\"batch_size\":1024,\"cbo_enable_replicated_join\":true,\"max_allowed_packet\":1048576,\"enable_cbo\":true,\"collation_server\":\"utf8_general_ci\",\"time_zone\":\"CST\",\"character_set_server\":\"utf8\",\"enable_pipeline\":true,\"cbo_use_nth_exec_plan\":0,\"rewrite_count_distinct_to_bitmap_hll\":true,\"parallel_exchange_instance_num\":-1,\"sql_mode\":34,\"allow_default_partition\":false}",
  "column_statistics":{
    "tpch_100g.nation_25_null":{
      "N_NATIONKEY":"[-Infinity, Infinity, 0.0, 1.0, 1.0] UNKNOWN"
    },
    "tpch_100g.customer_50_null":{
      "C_CUSTKEY":"[-Infinity, Infinity, 0.0, 1.0, 1.0] UNKNOWN"
    },
    "tpch_100g.orders":{
      "O_ORDERKEY":"[-Infinity, Infinity, 0.0, 1.0, 1.0] UNKNOWN"
    },
    "tpch_100g.part":{
      "P_PARTKEY":"[-Infinity, Infinity, 0.0, 1.0, 1.0] UNKNOWN"
    },
    "tpch_100g.lineitem_l":{
      "L_ORDERKEY":"[-Infinity, Infinity, 0.0, 1.0, 1.0] UNKNOWN"
    },
    "tpch_100g.orders_str_co":{
      "O_ORDERKEY":"[-Infinity, Infinity, 0.0, 1.0, 1.0] UNKNOWN"
    },
    "tpch_100g.partsupp_50_null":{
      "PS_PARTKEY":"[-Infinity, Infinity, 0.0, 1.0, 1.0] UNKNOWN"
    },
    "tpch_100g.customer_25_null":{
      "C_CUSTKEY":"[-Infinity, Infinity, 0.0, 1.0, 1.0] UNKNOWN"
    },
    "tpch_100g.partsupp":{
      "PS_PARTKEY":"[-Infinity, Infinity, 0.0, 1.0, 1.0] UNKNOWN"
    },
    "tpch_100g.region":{
      "R_REGIONKEY":"[-Infinity, Infinity, 0.0, 1.0, 1.0] UNKNOWN"
    },
    "tpch_100g.supplier_25_null":{
      "S_SUPPKEY":"[-Infinity, Infinity, 0.0, 1.0, 1.0] UNKNOWN"
    },
    "tpch_100g.region_5_null":{
      "R_REGIONKEY":"[-Infinity, Infinity, 0.0, 1.0, 1.0] UNKNOWN"
    },
    "tpch_100g.FLAT_TEST_TABLE":{
      "S_SUPPKEY":"[-Infinity, Infinity, 0.0, 1.0, 1.0] UNKNOWN"
    },
    "tpch_100g.test_all_type_select":{
      "id_tinyint":"[-Infinity, Infinity, 0.0, 1.0, 1.0] UNKNOWN"
    },
    "tpch_100g.orders_lco":{
      "O_ORDERKEY":"[-Infinity, Infinity, 0.0, 1.0, 1.0] UNKNOWN"
    },
    "tpch_100g.region_50_null":{
      "R_REGIONKEY":"[-Infinity, Infinity, 0.0, 1.0, 1.0] UNKNOWN"
    },
    "tpch_100g.orders_l":{
      "O_ORDERKEY":"[-Infinity, Infinity, 0.0, 1.0, 1.0] UNKNOWN"
    },
    "tpch_100g.customer_5_null":{
      "C_CUSTKEY":"[-Infinity, Infinity, 0.0, 1.0, 1.0] UNKNOWN"
    },
    "tpch_100g.orders_25_null":{
      "O_ORDERKEY":"[-Infinity, Infinity, 0.0, 1.0, 1.0] UNKNOWN"
    },
    "tpch_100g.partsupp_25_null":{
      "PS_PARTKEY":"[-Infinity, Infinity, 0.0, 1.0, 1.0] UNKNOWN"
    },
    "tpch_100g.customer":{
      "C_CUSTKEY":"[-Infinity, Infinity, 0.0, 1.0, 1.0] UNKNOWN"
    },
    "tpch_100g.orders_str":{
      "O_ORDERKEY":"[-Infinity, Infinity, 0.0, 1.0, 1.0] UNKNOWN"
    }
  },
  "be_number":3,
  "exception":[

  ],
  "version":"UNKNOWN",
  "commit_version":"9dcb87093"
}